Software Vault: The Gold Collection/Software Vault - The Gold Collection (American Databankers) (1993).ISO/cdr05/pdxwn693.zip/MAY93WIN.TIP

Text File | 1993-06-11 | 30KB | 972 lines

#: 31344 S1/Miscellaneous
    27-May-93  16:13:40
Sb: #Sys Resource Leak
Fm: Chris Paynter 76300,2451
To: all

We have noticed that Paradox for Windows tends to gobble system resources,
especially when repeatedly switching between design and run modes in an
application.  Even after exiting Paradox, the system resources are depleted.
Is there an acknowledged "memory leak" with Paradox, or is there something we
can do to alleviate this problem.  Also, are there known problems with memory
leaks in running Paradox for Windows applications?  We'll be concerned about
this when we go to deploy our apps.

Chris.

There are 2 Replies.

#: 31528 S1/Miscellaneous
    28-May-93  12:06:30
Sb: #31344-Sys Resource Leak
Fm: Dan Ehrmann (TeamB) 70007,4644
To: Chris Paynter 76300,2451 (X)

Chris:

Are you using a floating speedbar?  There is an acknowledged problem with this
config in v1.0.  Try setting the speedbar back to fixed along the top of the
screen.


[Dan -> ]



#: 31724 S1/Miscellaneous
    29-May-93  16:41:40
Sb: #Pdoxwin & Dos 6
Fm: Arne Snow 72124,3451
To: All

Upon installing Dos6 I am unable to use Pdoxwin. I am using a 386 DX40 with 4
megs of ram. I was able Pdoxwin under Dos 5. Now I get an Insuffiecient Memory
message and Pdoxwin refuses to even load or. Pdoxwin caused a not present
fault in Module KRNL 386.exe at 0002:098D. Sometimes Pdoxwin will load but it
is so slow I could go out for dinner while it changes screens.  Has any one
else experienced these problems. I am a new user to Paradox and had been
looking forward to developing applications. Now I may have to go back to
Access with where my applications run fine in DOS6

There are 3 Replies.

#: 31794 S1/Miscellaneous
    30-May-93  15:17:47
Sb: #31724-#Pdoxwin & Dos 6
Fm: Brian Bushay (TeamB) 76711,516
To: Arne Snow 72124,3451 (X)

Arne

>Upon installing Dos6 I am unable to use Pdoxwin. I am using a 386 DX40 with 4

There are a couple of common problems that Dos 6.0 causes when you install
it.  First is ignores current settings for SmartDrv.exe and will install
this disk cache with default parameters.  PdoxWin is a tight fit on a 4 meg
machine you can't afford to allocate too much memory to Smartdrv.exe

I recoment you use

SmartDrv.exe 512,256 in your Autoexec.bat

As second problem that Dos 6.0 cases it to mess up your Windows swap file.
You need a 4-6 meg perminant swapfile and the swapfile needs to be on an
uncompressed drive.

Brian

There is 1 Reply.

#: 31856 S1/Miscellaneous
    31-May-93  00:25:47
Sb: #31840-#.DBF files ?
Fm: Brian Bushay (TeamB) 76711,516
To: Bob Taylor 76304,155 (X)

Bob


>Is there any way to convert .dbf files to the Paradox (.db) format or vice
>versa?
You can copy one table type to the other.  Just specify the extension you
want when you give the new table its name.

Brian



There is 1 Reply.

#: 31892 S1/Miscellaneous
    31-May-93  11:17:04
Sb: #Problem w/ Ctrl-D?
Fm: Vikram Chandra 72617,2761
To: Borland

I have a field formatted for five decimal places, so the user can enter a
value like 0.9564.  When my user presses Ctrl-D in the next record, PdoxWin
copies over the value as 1.0.  Why?

        -- Vikram

There are 3 Replies.

#: 32151 S1/Miscellaneous
    01-Jun-93  15:35:47
Sb: #31892-#Problem w/ Ctrl-D?
Fm: Robert Ramirez (Sysop) 76702,255
To: Vikram Chandra 72617,2761 (X)

Hello Vikram,

Your Control Panel (International Settings) plays apart in how the number is
formatted.  Your decimal place setting must be set to 1 in order for it to
round the values like you've described.  Reset this setting to 5 and you'll
get the results your looking for.

~Robert
Borland Tech. Support

There is 1 Reply.

#: 31898 S1/Miscellaneous
    31-May-93  11:47:43
Sb: #Initial Page Display
Fm: Thomas D Anthony 71561,2144
To: Sysop (X)

I have a six Page Form and when the form opens it displays Page six first.
Page six contains a table object, the others contain text only.   I have
determined I can use setErrorCode in the canArrive method for the table object
to get it to open on page one, but all the examples I follow to reset the
error code after opening the form don't work. How do I dispatch an event to
reset the code so the user can update the table once the form is open? HELP
Tom

There are 3 Replies.

#: 31930 S1/Miscellaneous
    31-May-93  15:40:14
Sb: #31898-#Initial Page Display
Fm: Mike Irwin/Co-Assist 100114,1437
To: Thomas D Anthony 71561,2144 (X)

Thomas,

instead of the CanNotArrive, you can tell a form to go to a certain page from
code in the invoking form:

formvar.open() formvar.setPage() formvar.wait()

filling in the appropriate parameters, of course !

hope this helps

Mike

There is 1 Reply.

#: 31952 S1/Miscellaneous
    31-May-93  17:31:15
Sb: #Report View/Print Crash
Fm: Duane Erautt 76424,2253
To: all

  I have created a report consisting of around fifty lines that I am going to
use for a timetable.  The report crashes when you try to preview or print it.
I tried removing lines until, I got the report to the point where it wouldn't
crash.  I noticed that when previewing the report the report is drawn
immediately.  When I add one more line that will cause it to crash, I noticed
a long delay with a lot of disk access before it actually crashes. Almost no
disk activity occurs when the report is in a state that will preview
correctly.
  I've tried running this report on several computers, (486DX-33Mhz 16Megs
ram, 386SX-25, 386DX-35) with several different configurations.  Nothing seems
to make the least bit of difference.  I am prepared to upload the file so
anyone can check if it crashes their machine.

There is 1 Reply.

#: 32146 S1/Miscellaneous
    01-Jun-93  15:08:42
Sb: #31952-#Report View/Print Crash
Fm: Steve Neverve (Sysop) 71333,114
To: Duane Erautt 76424,2253 (X)

Duane,

How many objects are on your form?  Try making sure that your lines are not
crossing.  Also, select all of the objects, hold down the CTRL key and
right-click. Next, choose run time and uncheck fit width and fit height.

Steve

There is 1 Reply.

#: 32180 S1/Miscellaneous
    01-Jun-93  16:35:44
Sb: #32146-Report View/Print Crash
Fm: Duane Erautt 76424,2253
To: Steve Neverve (Sysop) 71333,114 (X)

In my report, I have around fifty lines. There are around three boxes.  The
lines do cross,  I will try changing the lines so that they don't cross, but
it seems pointless that paradox would not allow you to do this.  What I have
to create is a timetable outline, with lines breaking up the days of the week
as well as the hours of the day.  I have turned off the runtime resizing, but
it didn't help.

                                        THANKS

#: 32195 S1/Miscellaneous
    01-Jun-93  17:04:57
Sb: #File Locking w/Netw Lite
Fm: Dinyar Wadia 71042,3411
To: All

I have (2) computers using Novell Netware Lite 1.1. Each computer has its own
Paradox licenced software. Both computers can access all files with no
problem. The problem is that the record locking does not appear to be
operating. Both computers can access the same record and the status line says
that it is locked on both machines, but the record can be editted on both
machines. If I move off the record on each machine, and back to the record,
each machine maintains its own version of the record, I am not sure which
version gets saved in the end. Hopefully this will all make sense to someone.
Please help.

There is 1 Reply.

#: 32371 S1/Miscellaneous
    02-Jun-93  01:29:31
Sb: #32195-File Locking w/Netw Lite
Fm: Brian Bushay (TeamB) 76711,516
To: Dinyar Wadia 71042,3411 (X)

Dinyar


>each machine maintains its own version of the record, I am not sure which
>version gets saved in the end. Hopefully this will all make sense to someone.
>Please help.

You need to have DOS share loaded on both machines.
In the Config Utility
    You need to have "Local share On" checked.
    You need to both machines configured to use the .net file in the same
      Physical location.

Brian


#: 32492 S1/Miscellaneous
    02-Jun-93  14:22:34
Sb: #DOS app in button??
Fm: len burman 76520,3723
To: sysop (X)

In a form, I have a button, which when pressed, I would like to execute WP for
windows with a parameter which is a field in my form. I used the execute
command like   execute("wpwin.exe name") where name = filename.Value which is
a field in my form. It runs wpwin and looks for a file called   name. I want
the value which is in  name. I tried using \ and \\. I also tried defining a
field in my table as OLE, but since WP for windows is a client, I can't embed
it in my table field. How do I do this? When I press a button, I want to go
into WP for windows, with the filename which is in my form.

There is 1 Reply.

#: 32606 S1/Miscellaneous
    02-Jun-93  21:48:22
Sb: #32492-#DOS app in button??
Fm: Micah Bleecher(DataStar) 76570,234
To: len burman 76520,3723 (X)

>command like   execute("wpwin.exe name") where name = filename.Value which is
>a field in my form. It runs wpwin and looks for a file called   name. I want
>the value which is in  name. I tried using \ and \\. I also tried defining a

 Try execute("WPWIN.EXE " + name)

 (assumes name is a string variable and is assigned)


Micah

There is 1 Reply.

#: 32574 S1/Miscellaneous
    02-Jun-93  19:27:21
Sb: #Font Problems
Fm: Al Yanchak 71155,3065
To: All

I have a client who uses both PFW and Page Maker. Since installing Page Maker,
the PFW status bar has shrunk to a thin line and the text on the start up
screen is all messed up. I've heard that certain fonts loaded by Page Maker
can produce these problems with PFW. Any info would be appreciated.

Thanks in advance,

Al

There are 2 Replies.

#: 32846 S1/Miscellaneous
    03-Jun-93  15:49:34
Sb: #32574-Font Problems
Fm: Brian Reed (Sysop) 71333,2360
To: Al Yanchak 71155,3065

Al,

Yes, there are certain fonts from Pagemaker that will cause this.
Unfortunately, we haven't got them recorded here.  The lines to look at in the
Win.ini file are the [font substitutes] Helv = line and the Aldus section.
The Helv line should say Helv =  Ms Sans Serif. For the Aldus try commenting
out the fonts to see if the problem goes away.  If I find the name or names of
the actual fonts that are giving us grief I will post another message.

Hope this helps.

Brian Reed (sysop)


#: 32861 S1/Miscellaneous
    03-Jun-93  16:55:38
Sb: #32574-Font Problems
Fm: Brian Reed (Sysop) 71333,2360
To: Al Yanchak 71155,3065

Al,

As an addendum to my previous message I did manage to find the information on
which fonts cause us grief.

Comment out the lines in the font sections of the Win.ini that read: PageMaker
Fonts (2:1)=ALDFONTA.FON PageMaker Fonts (4:3)=ALDFONTB.FON PageMaker Fonts
(1:1)=TEDFONTF.FON

Brian Reed (sysop)


#: 31922 S2/Install/CFG/HrdWare
    31-May-93  14:37:41
Sb: #Starting Paradox
Fm: F C DASTOOR 76440,2017
To: sysop (X)

When I tried to start up Paradox for Windows I get a error message "unable to
initialise ODAPI -Directory is busy"

I have tried to restart after rebooting with no success. What is the problem?
What can I do to correct it?
Please help.

There is 1 Reply.

#: 31974 S2/Install/CFG/HrdWare
    31-May-93  20:07:53
Sb: #31922-Starting Paradox
Fm: John Rendell 70474,377
To: F C DASTOOR 76440,2017 (X)

F C

Delete any .lck and .net files.

       -Wig

#: 32343 S3/Tables/TableView
    01-Jun-93  22:56:42
Sb: #Assigning ID Numbers
Fm: David GoWell 75236,106
To: All

I have a lot of data in tables that I need to convert to PW.
I want to assign unique ID Numbers to these records to serve as
Primary Key. Once each record has an ID_Num, I know there are ways to
increment each new ID_Num. But to get started, can I assign the Record Number
to the ID_Num field? Any help in the area of ID Numbers, unique Keys,
incrementing, etc., would be greatly appreciated.

There are 2 Replies.

#: 32406 S3/Tables/TableView
    02-Jun-93  09:06:28
Sb: #32343-Assigning ID Numbers
Fm: Dan Ehrmann (TeamB) 70007,4644
To: David GoWell 75236,106 (X)

David:

Import your data into an empty, unkeyed table.  Then restructure the table and
add an ID field at the beginning, still unkeyed.

Then create the following script:

       var
          TC   TCursor
       endvar

       TC.open("YourTable")
       TC.edit()
       scan TC:
          TC."YourIDField" = TC.recNo()    ; check this method name
                                           ; I don't have a manual handy
       endscan
       TC.endEdit()
       TC.close()



[Dan -> ]



#: 31900 S4/Forms
    31-May-93  12:14:03
Sb: #Flyaway Problems
Fm: Jeffrey L. Odell 71461,1064
To: Sysop (X)

I am having no luck implementing the canDepart method on page 328 of the
developers guide.  I have a form, 1 ---> M
                                                |----> M ---->M
The master table is implemented as a multi record object with only one record
displayed.  I've attached the flyaweay method to the multi-record block and
the individual record, to no avail.

Has anyone sucessfully implemented this code?  When my user enters data into
the master record, I want that record to stay current when the user leaves the
block.

Thanks -
Jeff Odell


There is 1 Reply.

#: 32083 S4/Forms
    01-Jun-93  12:32:56
Sb: #31900-#Flyaway Problems
Fm: Rick Fillman (Sysop) 76702,273
To: Jeffrey L. Odell 71461,1064 (X)

 > I am having no luck implementing the canDepart method on page 328
 > of the developers guide.

The example code on p. 328 of teh Developer's Guide is inaccurate
The recommended approach is:

method action(var eventInfo ActionEvent)
 ; this code is attached to a TableFrame or MRO
   if eventInfo.id() = DataUnlockRecord then
      self.action(DataPostRecord)
   endIf
endmethod

Try it.  The above allows for use to "follow" the records to its
new location in the table.

    Rick Fillman, Tech Support (Borland)

There is 1 Reply.

#: 31956 S4/Forms
    31-May-93  18:38:37
Sb: #Form execution of query
Fm: Fred  W. Kulikoff 71712,2521
To: Anyone who can help

Help! anyone.
        I am a new Paradox for Windows user and have just stared to learn the
ObjectPal language. I have been trying to get a query to execute from a form
using the syntax:

method pushButton(var eventInfo Event)
var
        tv TableView
endvar
executeQBEFile("bldgserv.qbe", "bldgserv.db")
tv.open("bldgserv.db")
endmethod

The query does execute but the resulting table does not contain all the
information that it does when I execute the query from the folder. The
existing QBE file contains many calculated fields. The resulting table when
run from the folder corrrectly shows all of these fields. When run from the
form the table has many of these fields blank. The field headings are there
but the results are not.
        What am I doing wrong? Any help would be greatly appreciated.

There is 1 Reply.

#: 32085 S4/Forms
    01-Jun-93  12:33:06
Sb: #31956-Form execution of query
Fm: Rick Fillman (Sysop) 76702,273
To: Fred  W. Kulikoff 71712,2521


Under certain circumstances, executeQBEFile can produce results
which differ (from that which you get by manually executing the
query).  These circumstances are ones where there are blank
values in the fields involved in the calculations.

If this is your circumstance, you can get accurate results by
switching to executeQBE instead.  See the example on p.349 of the
Opal Ref. book.

Tip:  With executeQBE you will actually embed the query
definition IN you OPal code - but don't try to type it in.  You
ALREADY have what you need in your QBE file.  So, perform
Edit|Paste from File while you are in OPal Edit mode.  Name the
existing QBE file, and the text description of the query will
show up.

     Rick Fillman, Tech Support (Borland)

#: 32001 S4/Forms
    31-May-93  23:25:30
Sb: #Misc
Fm: Bradley Tubbs 70702,3245
To: sysop (X)

How can I delete a parent record and all of its dependents on a form?

There is 1 Reply.

#: 32087 S4/Forms
    01-Jun-93  12:33:15
Sb: #32001-Misc
Fm: Rick Fillman (Sysop) 76702,273
To: Bradley Tubbs 70702,3245 (X)

 > How can I delete a parent record and all of its dependents on a
 > form?

If you have definded Ref.Int between the Parent and child table,
you will have to delete the record(s) in the child table
(yourself) first.

Using OPal, this would go something like:

tc.attach(ChildTableObject)
tc.edit()
while tc.nrecords>0
     tc.deleterecord()
     ; don't need to worry about moving the record pointer here
     ; if the deleteRecords works, the pointer advances to the next
     ; remaining record
endwhile

     Rick Fillman, Tech Support (Borland)

#: 32353 S4/Forms
    01-Jun-93  23:41:57
Sb: #Detail Object Updating
Fm: Mark Olbert 73557,1512
To: Sysop (X)

I have a form based on the following data model:

    A -->B
    +-->>C-->>D

The '>>' indicates a 1 to M linkage (which I think is the 'syntax' used in
PdoxWin).

When I scroll through the form normally, the master and allof the details
update normally.  But when I do a Ctrl Z on a field in 'A', the A object
updates but the B, C and D objects are set to some kind of end of file/new
record condition (woops, I forgot to mention this occurs in edit mode).  I can
 display the data in the B, C and D objects by either manually doing a HOME on
each of them, or by inserting a UIObject.home() function in the action()
method for the A object (on a DataArriveRecord event).

Why should I have to do this?  Why don't the detail objects display the first
record in their restricted sets?

????Mark????

There is 1 Reply.

#: 32554 S4/Forms
    02-Jun-93  17:49:00
Sb: #32353-#Detail Object Updating
Fm: Rick Fillman (Sysop) 76702,273
To: Mark Olbert 73557,1512 (X)


For the time being, the reliable way to get the records on the
detail table to appear (following a successful Ctrl-Z search in
the Master table) is to start that search from the first record
of the master table.  You _could_ move the record pointer to the
first record in the table.

Here's a piece of ObjectPal code you can you to make that
automatic.  Attach this to the Action Method of the form:

; --- along the way to MenuLocateRecordValue,
;     move pointer to top, first
if eventinfo.id()=dataSearch then
    ; move pointer to top of file
        home()
    endif

Hope this helps.

    Rick Fillman, Tech Support (Borland)

There is 1 Reply.

#: 32646 S4/Forms
    03-Jun-93  01:15:02
Sb: #32554-#Detail Object Updating
Fm: Mark Olbert 73557,1512
To: Rick Fillman (Sysop) 76702,273 (X)

Fascinating.  Is this a WAD or a buglet?  In either event, what's odd is that
the problem doesn't occur in all forms..

BTW:  does dataSearch get sent to the action() method when you start the
search from the menu, or just when you do a Ctrl-Z?

- Mark

There is 1 Reply.

#: 32774 S4/Forms
    03-Jun-93  13:18:17
Sb: #32646-Detail Object Updating
Fm: Rick Fillman (Sysop) 76702,273
To: Mark Olbert 73557,1512

 > does dataSearch get sent to the action() method when you
 > start the search from the menu, or just when you do a Ctrl-Z?

Either.  That's why I used dataSearch (rather than checking for
the MenuRecordLocateValue) constant.  The phenonmenon should
appear in any form, BTW.

     Rick Fillman, Tech Support (Borland)

#: 33945 S3/Tables/TableView
    08-Jun-93  18:53:54
Sb: #Automatic Date Entry
Fm: Robert B. Lamishaw 76416,773
To: all

Hi,

I'm new to Parodxo for Windows and am trying to create my first application.
So far it seems to be OK although I would like to have the computer
automatically entry a date (only no time) stamp in a field I have defined in
the table.  I want to know when the record was entered into  the system for
historical purposes only.  This filed will not be editable, it will only be
for view and search functions.  What I cann't figure out is how to make the
system fill in the field automatically.  I've used many other database systems
and most have a function that you define in the data dictionary that will
perform this function for you, similiar to the default option in Paradox.

If anyone can direct me how to do this I'd be most grateful.  I am hoping that
I don't have to get into ObjectPal at this point.  Thanks for the help.

There are 2 Replies.

#: 34083 S3/Tables/TableView
    09-Jun-93  11:53:34
Sb: #33945-#Automatic Date Entry
Fm: David Orriss Jr(Sysop) 75300,1414
To: Robert B. Lamishaw 76416,773 (X)

Robert,

> So far it seems to be OK although I would like to have the computer
> automatically entry a date (only no time) stamp in a field I have defined
> in the table.

In table creation mode or table restructure mode, move to the date field in
your table structure format, Press Alt-4 (this moves you to the "Default"
prompt in the table restructure dialog), and type TODAY.  I hope this helps.

David

There is 1 Reply.

#: 33731 S4/Forms
    07-Jun-93  23:49:25
Sb: #Quick Form
Fm: Peg M. Molter 72134,2727
To: All

I am a brand new Paradox user, although I've had a little with D-Base IV.
While following the documentation on how to create a quick form, then exit:  I
double click on the form's control menu.  It brings up the prompt

        Newly created document
                Form:  New
        Do you want to save it?

When I answer "yes," I'm supposed to be taken to the "Save File As" dialog
box.  Instead, I'm taken to the Forms Design window.  When I double click on
THAT control menu, it brings up the same "save" prompt, and when I answer
"yes," I'm then taken to the dialog box described above.  All the
documentation indicates  I shouldn't be going through the design window when
saving the quick form.  Any suggestions?

Thanks for your patience with a really basic-type question. - - - Peg

There are 2 Replies.

#: 33906 S4/Forms
    08-Jun-93  16:06:02
Sb: #33731-#Quick Form
Fm: Quinn Wildman (Sysop) 76703,3033
To: Peg M. Molter 72134,2727 (X)

The product is operating as indended here.  The idea is that a form can only
be saved when you are in design mode, so if you tell a form to save itself
from run mode, it takes you to design mode so it can be saved.

There is 1 Reply.

#: 33611 S5/Reports
    07-Jun-93  17:46:21
Sb: #Print Report to File????
Fm: Larry Chop 73700,2317
To: Sysop (X)

In interactive mode, when I try to select the Generic / Text Only - File
printer (which works well on any other application, I get the dialog message
        Printer Error
No Printer Fonts Available, printing diabled

What's up? I had just tested printing to the Generic / Text Only - File
printer in Windows Write - worked great.
Why not in PfW, especially in the interactive mode??

Larry

There is 1 Reply.

#: 34102 S5/Reports
    09-Jun-93  12:52:52
Sb: #33611-#Print Report to File????
Fm: Scott Arnett (Sysop) 76711,650
To: Larry Chop 73700,2317 (X)

Larry-

Make sure that you do not have Windows set to use only True Type fonts.  Go
into the control panel and select Fonts and True Type.  Make sure that "Show
Only True Type Fonts in Applications" is not checked.

-
Scott


There is 1 Reply.

#: 33763 S5/Reports
    08-Jun-93  05:46:04
Sb: #reports
Fm: Stephen De Marco 73112,3310
To:  73112,3310 (X)

Reference the problem printing on an ASCII printer. If I have the printer
selection set correctly to the ASCII printer, then the table comes up in Roman
type, and it prints OKay. But, if I run a query on that table the ANSWER is in
Arial type anint. I have to select each element of the answer table and change
it to Roman. There should be a better way. Is there a system session setting
that has tables, reports, queries, etc. all come up in a particular font?

There is 1 Reply.

#: 34154 S5/Reports
    09-Jun-93  15:57:50
Sb: #33763-reports
Fm: Scott Arnett (Sysop) 76711,650
To: Stephen De Marco 73112,3310

Stephen-

If you want to set a default font for your answer table do this:

1) Open the quewry and choose Properties | Answer Table | Options

2) Click on the image of the Answer table and do Shift+Ctrl+M.

3) Set the font you want, and click OK.

4) Save the query.

This will allow you to set a default font for that query.

-Scott


#: 33913 S5/Reports
    08-Jun-93  16:56:42
Sb: #output to a file
Fm: Tom Haley 72212,3477
To: Sysop (X)

Is there a way to direct the output of a report to an ascii file?

Sometimes the output needs massaged for reports......

thanks.
tom

There is 1 Reply.

#: 34159 S5/Reports
    09-Jun-93  15:58:12
Sb: #33913-output to a file
Fm: Scott Arnett (Sysop) 76711,650
To: Tom Haley 72212,3477

Tom-

To output to an ASCII file you need to set up the Generic Print driver in
Windows Control Panel and set it to output to a file.  Then use that driver
to print your report.

-Scott


#: 34260 S10/ObjectPAL Environ.
    09-Jun-93  21:28:51
Sb: #Business days passed
Fm: Jim White 73530,207
To: All

Has anyone got any ideas as to how I might calculate business days passed in a
field under reports in PDOX/WIN?
I have a client who wishes to document the number of business days passed
between the opening of a service call and its close.  The problem that I am
having difficulty with is determining how to calculate out weekends, and,
possibly, holidays, from this equation.
Any suggestions would be very much appreciated.
Thanks,
==>Jim

There is 1 Reply.

#: 34283 S10/ObjectPAL Environ.
    09-Jun-93  23:08:46
Sb: #34260-Business days passed
Fm: Les Gainous 72731,146
To: Jim White 73530,207

RE:  how I might calculate business days passed

Jim,

This is very rough "pseudocode" (in other words, the syntax may not be
100%).  This is only one way to do it using ObjectPAL.

{-----------------------------------------------------------------}
elpBusDays = 0
numDays = endDate - beginDate {assuming these dates are valid}

for i from 1 to numDays
  if subStr((dow(beginDate + i)),1,1) <> "S" then
    {the day must not start with the letter S, so lets count it.
     caveat: weekday holidays are not checked!}
    elpBusDays = elpBusDays + 1
  endIf
endFor

stmt = "The number of elapsed business days is:" + strVal(elpBusDays)
msgInfo("Result",stmt)

{-----------------------------------------------------------------}

goodLuck()  Les  72731,146

#: 34109 S13/Addins/Training
    09-Jun-93  13:07:19
Sb: #Paradox Users Conference
Fm: Alan Zenreich 71171,1340
To: PALs

Greetings,

* Are you hungry for the latest Paradox techniques and tips?
* Do you want to pick the brains of some of the best Paradox talent
  around?
* Do you miss the intimacy of a conference that deals only with
  Paradox and Paradox for Windows?
* Does your boss refuse to send you to the West Coast?

Have I got news for you!  I'm pleased to announce the upcoming

            Paradox Users Conference
            September 26 - 29, 1993
            Walt Disney World Swan Hotel
            Lake Buena Vista, Florida

This conference, set on the grounds of Disney World, is likely to be
closer in size (and tone) to the original Paradox conference in Monterey,
anticpating somehwere between 900 and 1500 people.

The conference is devoted exclusively to Paradox and Paradox for
Windows, with sessions for both end users and developers.

Topics include interactive Paradox and Paradox for Windows, PAL and
ObjectPAL programming, and multiuser/Client-Server issues.  Discover
sophisticated Paradox 4.0 programming techniques.  Gain an understanding
of the Paradox for Windows programming environment.

Share experiences with Developers from around the world.

The instructors are world class, some of the best known and highly
rated in the industry (both for their technical expertise and teaching
abilities).  In alphabetical order:

   Luke Chung          Mark Pauker
   Joe Clark           Greg Salcedo
   Tim Colling         Ken Schachat
   Dan Ehrmann         Kevin Smith
   Joe Fung            Martin Rudy
   Jim Kocis           Ben Tandowski
   Dan Paolini         Bill Todd
                       Alan Zenreich

Although this is an independant conference, it has Borland's support.
Borland International will be giving the Keynote address, and
several Borland speakers will present technical sessions.

The registration fee is $895.00 per person, however an Early-Bird
registration fee of only $795.00 has been extended through mid August.
Space is limited, so register early!

The room rate is $130 per night (a pretty good deal considering Microsoft
held their Tech-Ed conference in this hotel and the room rate was $180
per night).

For additional information, contact:

   The Paradox Users Conferene Hotline

   800-942-8872
   203-261-6227
   Fax [phone]

   731 Main Street, Suite C-3
   Monroe, CT 06468


I hope to see lots of you there!!







There is 1 Reply.